package com.ado.agea.pruebas;

import java.io.File;
import java.io.FileNotFoundException;
import java.util.Scanner;

public class Revista {
	public static void main(String... args) {
		File f = new File("conceptosRevista.txt");
		Scanner sc;
		try {
			sc = new Scanner(f);
			while (sc.hasNext()) {
				String linea = sc.nextLine();
				int begin = linea.indexOf("(");
				if (begin >= 0) {
					linea= linea.substring(0, begin);
				}
				System.out.println("INSERT INTO `revista` (`nombre`) VALUES('" + linea.trim().toUpperCase() + "');");
			}
			sc.close();
		} catch (FileNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

	}
}
